<?php !defined('DYHB_PATH') && exit; /* DoYouHaoBaby Framework 模板缓存文件 生成时间：2011-05-28 11:37:39  */ ?>
<?php $this->includeChildTemplate( "".APP_PATH."/Tpl/Default/public_header.html" ,"" ,"" ,"" )  ;?>

   <!-- 标题  -->
   <div class="title"><?php print G::L( "数据库优化", null, null ) ; ?> ( <a href="<?php echo( G::U('backup/index') );?>"><?php print G::L( "数据库备份", null, null ) ; ?></a> | <a href="<?php echo( G::U('backup/restore') );?>"><?php print G::L( "数据库恢复", null, null ) ; ?></a> |<a href="<?php echo( G::U('backup/runsql') );?>"><?php print G::L( "运行SQL语句", null, null ) ; ?></a> )</div>

  <!-- 正文 -->
  <div id="content" class="content">
       <form action="<?php echo( G::U('backup/run_optimize') );?>" method="post" id="tableList" >
      <table class="form-table full">
          <tr>
              <th valign="top"><label for="num"  class="field"><?php print G::L( "优化操作", null, null ) ; ?> </label></td>
              <td><input type= "hidden" name= "num" value = "<?php echo( $nNum ); ?>">
              <input type="submit" value="  <?php print G::L( "开始进行数据库表优化", null, null ) ; ?>   " class="button" />
              <div class="description"><?php print G::L( "及时清理数据库碎片，能够加快数据库查询速度", null, null ) ; ?></div>
              <div class="warning"><?php print G::L( "总碎片数", null, null ) ; ?>:<?php echo( $nNum ); ?></div></td>
            </tr>

      </table>
        <table class="data full" id="checkList">
        <thead>
         <tr>
           <th><?php print G::L( "数据表", null, null ) ; ?></th>
           <th><?php print G::L( "数据表类型", null, null ) ; ?></th>
           <th><?php print G::L( "记录数", null, null ) ; ?></th>
           <th><?php print G::L( "数据", null, null ) ; ?></th>
           <th><?php print G::L( "碎片", null, null ) ; ?></th>
           <th><?php print G::L( "字符集", null, null ) ; ?></th>
           <th><?php print G::L( "状态", null, null ) ; ?></th>
        </tr>
        </thead>
        <tbody>
        <?php $i=1 ;?>
<?php if( is_array( $arrList ) ) : foreach( $arrList as $key=>$value): ?>

         <tr>
          <td><?php echo( $value['table'] ); ?></td>
          <td><?php echo( $value['type'] ); ?></td>
          <td><?php echo( $value['rec_num'] ); ?></td>
          <td><?php echo( $value['rec_size'] ); ?></td>
          <td><?php echo( $value['rec_chip'] ); ?></td>
          <td><?php echo( $value['charset'] ); ?></td>
          <td><?php echo( $value['status'] ); ?></td>
        </tr>
        
<?php $i++ ;?>
<?php endforeach;endif; ?>
        </tbody>
        </table>
        <table class="form-table full">
          <tr>
              <th valign="top"><label for="node_title"  class="field"><?php print G::L( "优化操作", null, null ) ; ?> </label></td>
              <td><input type= "hidden" name= "num" value = "<?php echo( $nNum ); ?>">
              <input type="submit" value="  <?php print G::L( "开始进行数据库表优化", null, null ) ; ?>   " class="button" />
              <div class="description"><?php print G::L( "及时清理数据库碎片，能够加快数据库查询速度", null, null ) ; ?></div></td>
            </tr>

      </table>
      </form>

   </div>
   <!-- end content -->

<?php $this->includeChildTemplate( "".APP_PATH."/Tpl/Default/public_footer.html" ,"" ,"" ,"" )  ;?>